package com.carkeeper.userbill.dao;

import com.carkeeper.userbill.pojo.UserBill;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

@Repository
public interface UserBillMapper extends Mapper<UserBill> {

    @Select("select * from tb_user_bill where code = #{code}")
    public UserBill findByCode(String code);

    @Select("select pay_status from tb_user_bill group by pay_status")
    List<String> findByPayStatus();

    @Select("select subtype_name from tb_user_bill group by subtype_name")
    List<String> findBySubtypeName();
}
